Airbnb Profiling Report

Dataset statistics

Number of variables	18
Number of observations	36008
Missing cells	94400
Missing cells (%)	14.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.9 MiB
Average record size in memory	144.0 B

Variable types

Numeric	11
Text	3
Unsupported	2
Categorical	1
DateTime	1

Alerts

`latitude` is highly overall correlated with `longitude`	High correlation
`longitude` is highly overall correlated with `latitude`	High correlation
`number_of_reviews` is highly overall correlated with `number_of_reviews_ltm` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly overall correlated with `number_of_reviews` and 1 other fields	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews` and 1 other fields	High correlation
`room_type` is highly imbalanced (58.4%)	Imbalance
`neighbourhood_group` has 36008 (100.0%) missing values	Missing
`price` has 1771 (4.9%) missing values	Missing
`last_review` has 10302 (28.6%) missing values	Missing
`reviews_per_month` has 10302 (28.6%) missing values	Missing
`license` has 36008 (100.0%) missing values	Missing
`price` is highly skewed (γ1 = 66.96707573)	Skewed
`minimum_nights` is highly skewed (γ1 = 28.22092657)	Skewed
`id` has unique values	Unique
`neighbourhood_group` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`license` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`number_of_reviews` has 10302 (28.6%) zeros	Zeros
`availability_365` has 5475 (15.2%) zeros	Zeros
`number_of_reviews_ltm` has 14214 (39.5%) zeros	Zeros

Reproduction

Analysis started	2024-04-27 15:57:43.905576
Analysis finished	2024-04-27 15:58:30.662447
Duration	46.76 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

id
Real number (ℝ)

UNIQUE

Distinct	36008
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4457301 × 10¹⁷

Minimum	17878
Maximum	1.0538233 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	17878
5-th percentile	2958870.7
Q1	28637937
median	5.7613679 × 10¹⁷
Q3	8.7267609 × 10¹⁷
95-th percentile	1.0398874 × 10¹⁸
Maximum	1.0538233 × 10¹⁸
Range	1.0538233 × 10¹⁸
Interquartile range (IQR)	8.7267609 × 10¹⁷

Descriptive statistics

Standard deviation	4.4185817 × 10¹⁷
Coefficient of variation (CV)	0.99389336
Kurtosis	-1.8169913
Mean	4.4457301 × 10¹⁷
Median Absolute Deviation (MAD)	4.7330968 × 10¹⁷
Skewness	0.089169612
Sum	-3.5887837 × 10¹⁸
Variance	1.9523864 × 10³⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
216461	1	< 0.1%
6.074455479 × 10¹⁷	1	< 0.1%
6.074073247 × 10¹⁷	1	< 0.1%
6.043327156 × 10¹⁷	1	< 0.1%
6.07416832 × 10¹⁷	1	< 0.1%
6.04350575 × 10¹⁷	1	< 0.1%
6.008074554 × 10¹⁷	1	< 0.1%
6.008473518 × 10¹⁷	1	< 0.1%
6.008841958 × 10¹⁷	1	< 0.1%
6.007433303 × 10¹⁷	1	< 0.1%
Other values (35998)	35998	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17878	1	< 0.1%
25026	1	< 0.1%
35764	1	< 0.1%
41198	1	< 0.1%
48305	1	< 0.1%
48901	1	< 0.1%
49179	1	< 0.1%
50759	1	< 0.1%
51703	1	< 0.1%
53533	1	< 0.1%

Value	Count	Frequency (%)
1.053823262 × 10¹⁸	1	< 0.1%
1.053808194 × 10¹⁸	1	< 0.1%
1.05378934 × 10¹⁸	1	< 0.1%
1.053756202 × 10¹⁸	1	< 0.1%
1.053746406 × 10¹⁸	1	< 0.1%
1.053743193 × 10¹⁸	1	< 0.1%
1.053736264 × 10¹⁸	1	< 0.1%
1.053720091 × 10¹⁸	1	< 0.1%
1.053716797 × 10¹⁸	1	< 0.1%
1.053711356 × 10¹⁸	1	< 0.1%

name
Text

Distinct	14150
Distinct (%)	39.3%
Missing	0
Missing (%)	0.0%
Memory size	281.4 KiB

Length

Max length	167
Median length	92
Mean length	62.758248
Min length	31

Characters and Unicode

Total characters	2259799
Distinct characters	92
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10847 ?
Unique (%)	30.1%

Sample

1st row	Rental unit in Rio de Janeiro · 1 bedroom · 1 bed · 1 bath
2nd row	Rental unit in Rio de Janeiro · 2 bedrooms · 5 beds · 3 baths
3rd row	Rental unit in Rio de Janeiro · 1 bedroom · 2 beds · 2.5 baths
4th row	Home in Rio de Janeiro · 1 bedroom · 1 bed · 1 bath
5th row	Rental unit in Rio de Janeiro · 1 bedroom · 2 beds · 1 bath

Value	Count	Frequency (%)
·	132069	23.3%
1	52893	9.4%
in	36008	6.4%
2	27550	4.9%
rental	26976	4.8%
unit	26976	4.8%
rio	25052	4.4%
de	24336	4.3%
janeiro	24223	4.3%
beds	23303	4.1%
Other values (494)	166266	29.4%

Most occurring characters

Value	Count	Frequency (%)
	529873	23.4%
e	170589	7.5%
o	138339	6.1%
·	132069	5.8%
n	126164	5.6%
a	125079	5.5%
i	120678	5.3%
b	110655	4.9%
d	105714	4.7%
t	100258	4.4%
Other values (82)	600381	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2259799	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	529873	23.4%
e	170589	7.5%
o	138339	6.1%
·	132069	5.8%
n	126164	5.6%
a	125079	5.5%
i	120678	5.3%
b	110655	4.9%
d	105714	4.7%
t	100258	4.4%
Other values (82)	600381	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2259799	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	529873	23.4%
e	170589	7.5%
o	138339	6.1%
·	132069	5.8%
n	126164	5.6%
a	125079	5.5%
i	120678	5.3%
b	110655	4.9%
d	105714	4.7%
t	100258	4.4%
Other values (82)	600381	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2259799	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	529873	23.4%
e	170589	7.5%
o	138339	6.1%
·	132069	5.8%
n	126164	5.6%
a	125079	5.5%
i	120678	5.3%
b	110655	4.9%
d	105714	4.7%
t	100258	4.4%
Other values (82)	600381	26.6%

host_id
Real number (ℝ)

Distinct	21980
Distinct (%)	61.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.784179 × 10⁸

Minimum	1671
Maximum	5.5271448 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	1671
5-th percentile	2981903.8
Q1	24167859
median	96445730
Q3	3.2560925 × 10⁸
95-th percentile	5.0692743 × 10⁸
Maximum	5.5271448 × 10⁸
Range	5.5271281 × 10⁸
Interquartile range (IQR)	3.0144139 × 10⁸

Descriptive statistics

Standard deviation	1.7696843 × 10⁸
Coefficient of variation (CV)	0.99187597
Kurtosis	-0.90013792
Mean	1.784179 × 10⁸
Median Absolute Deviation (MAD)	86663858
Skewness	0.75158178
Sum	6.4244719 × 10¹²
Variance	3.1317825 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6000862	185	0.5%
91654021	157	0.4%
341887136	145	0.4%
1982737	142	0.4%
47584281	142	0.4%
371026651	128	0.4%
14315601	85	0.2%
74463624	80	0.2%
30165706	77	0.2%
12909867	69	0.2%
Other values (21970)	34798	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1671	1	< 0.1%
3607	1	< 0.1%
11739	9	< 0.1%
19065	3	< 0.1%
34105	2	< 0.1%
37072	1	< 0.1%
48024	7	< 0.1%
60098	1	< 0.1%
64036	2	< 0.1%
68997	1	< 0.1%

Value	Count	Frequency (%)
552714482	1	< 0.1%
552420950	1	< 0.1%
552339316	1	< 0.1%
552326533	1	< 0.1%
552283430	1	< 0.1%
552282629	1	< 0.1%
552267363	1	< 0.1%
552264669	1	< 0.1%
552258899	1	< 0.1%
552258099	1	< 0.1%

host_name
Text

Distinct	6268
Distinct (%)	17.4%
Missing	9
Missing (%)	< 0.1%
Memory size	281.4 KiB

Length

Max length	34
Median length	32
Mean length	7.3657602
Min length	1

Characters and Unicode

Total characters	265160
Distinct characters	105
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3526 ?
Unique (%)	9.8%

Sample

1st row	Zeilma , Da
2nd row	Priscila
3rd row	Rachel
4th row	Maria
5th row	Katiuscia

Value	Count	Frequency (%)
maria	894	2.1%
ana	581	1.3%
rio	516	1.2%
carlos	493	1.1%
luiz	382	0.9%
daniel	359	0.8%
rodrigo	336	0.8%
ricardo	332	0.8%
pedro	331	0.8%
rafael	319	0.7%
Other values (5070)	38787	89.5%

Most occurring characters

Value	Count	Frequency (%)
a	40312	15.2%
i	24676	9.3%
e	21035	7.9%
r	18618	7.0%
o	18004	6.8%
n	17664	6.7%
l	14927	5.6%
s	9166	3.5%
u	7752	2.9%
d	7368	2.8%
Other values (95)	85638	32.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	265160	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	40312	15.2%
i	24676	9.3%
e	21035	7.9%
r	18618	7.0%
o	18004	6.8%
n	17664	6.7%
l	14927	5.6%
s	9166	3.5%
u	7752	2.9%
d	7368	2.8%
Other values (95)	85638	32.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	265160	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	40312	15.2%
i	24676	9.3%
e	21035	7.9%
r	18618	7.0%
o	18004	6.8%
n	17664	6.7%
l	14927	5.6%
s	9166	3.5%
u	7752	2.9%
d	7368	2.8%
Other values (95)	85638	32.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	265160	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	40312	15.2%
i	24676	9.3%
e	21035	7.9%
r	18618	7.0%
o	18004	6.8%
n	17664	6.7%
l	14927	5.6%
s	9166	3.5%
u	7752	2.9%
d	7368	2.8%
Other values (95)	85638	32.3%

neighbourhood_group
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	36008
Missing (%)	100.0%
Memory size	281.4 KiB

neighbourhood
Text

Distinct	156
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	281.4 KiB

Length

Max length	24
Median length	22
Mean length	10.281743
Min length	3

Characters and Unicode

Total characters	370225
Distinct characters	60
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	Flamengo
2nd row	Santa Teresa
3rd row	Copacabana
4th row	Jardim Botânico
5th row	Barra da Tijuca

Value	Count	Frequency (%)
copacabana	10982	21.7%
tijuca	3953	7.8%
barra	3653	7.2%
da	3639	7.2%
ipanema	3455	6.8%
jacarepaguá	1813	3.6%
recreio	1804	3.6%
dos	1804	3.6%
bandeirantes	1804	3.6%
leblon	1742	3.4%
Other values (186)	16035	31.6%

Most occurring characters

Value	Count	Frequency (%)
a	91184	24.6%
o	27519	7.4%
n	25976	7.0%
e	24028	6.5%
r	20318	5.5%
c	19773	5.3%
p	16524	4.5%
	14676	4.0%
C	14193	3.8%
b	13340	3.6%
Other values (50)	102694	27.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	370225	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	91184	24.6%
o	27519	7.4%
n	25976	7.0%
e	24028	6.5%
r	20318	5.5%
c	19773	5.3%
p	16524	4.5%
	14676	4.0%
C	14193	3.8%
b	13340	3.6%
Other values (50)	102694	27.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	370225	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	91184	24.6%
o	27519	7.4%
n	25976	7.0%
e	24028	6.5%
r	20318	5.5%
c	19773	5.3%
p	16524	4.5%
	14676	4.0%
C	14193	3.8%
b	13340	3.6%
Other values (50)	102694	27.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	370225	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	91184	24.6%
o	27519	7.4%
n	25976	7.0%
e	24028	6.5%
r	20318	5.5%
c	19773	5.3%
p	16524	4.5%
	14676	4.0%
C	14193	3.8%
b	13340	3.6%
Other values (50)	102694	27.7%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	18712
Distinct (%)	52.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-22.96758

Minimum	-23.073276
Maximum	-22.74969
Zeros	0
Zeros (%)	0.0%
Negative	36008
Negative (%)	100.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	-23.073276
5-th percentile	-23.014033
Q1	-22.984712
median	-22.97286
Q3	-22.956277
95-th percentile	-22.910943
Maximum	-22.74969
Range	0.323586
Interquartile range (IQR)	0.0284345

Descriptive statistics

Standard deviation	0.034686657
Coefficient of variation (CV)	-0.0015102443
Kurtosis	4.1290957
Mean	-22.96758
Median Absolute Deviation (MAD)	0.01227
Skewness	1.2785008
Sum	-827016.63
Variance	0.0012031642
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-22.99804	54	0.1%
-22.980897	36	0.1%
-22.980449	25	0.1%
-23.01137	24	0.1%
-22.98456	20	0.1%
-22.9643	20	0.1%
-22.98525	19	0.1%
-22.960804	19	0.1%
-22.98361	18	< 0.1%
-22.98253	18	< 0.1%
Other values (18702)	35755	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23.073276	1	< 0.1%
-23.07305	1	< 0.1%
-23.07284	1	< 0.1%
-23.072737	1	< 0.1%
-23.07262	1	< 0.1%
-23.07241	1	< 0.1%
-23.0722	2	< 0.1%
-23.072154	1	< 0.1%
-23.07215	1	< 0.1%
-23.07211	1	< 0.1%

Value	Count	Frequency (%)
-22.74969	1	< 0.1%
-22.74995	1	< 0.1%
-22.75051	1	< 0.1%
-22.75061	1	< 0.1%
-22.750692	1	< 0.1%
-22.75077	1	< 0.1%
-22.75094	1	< 0.1%
-22.75144	1	< 0.1%
-22.75195	1	< 0.1%
-22.75239	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	20869
Distinct (%)	58.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-43.249377

Minimum	-43.723009
Maximum	-43.1044
Zeros	0
Zeros (%)	0.0%
Negative	36008
Negative (%)	100.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	-43.723009
5-th percentile	-43.471277
Q1	-43.306566
median	-43.194825
Q3	-43.185573
95-th percentile	-43.174845
Maximum	-43.1044
Range	0.618609
Interquartile range (IQR)	0.120993

Descriptive statistics

Standard deviation	0.099240937
Coefficient of variation (CV)	-0.0022946212
Kurtosis	1.2008506
Mean	-43.249377
Median Absolute Deviation (MAD)	0.017098
Skewness	-1.4714597
Sum	-1557323.5
Variance	0.0098487635
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-43.256821	58	0.2%
-43.422441	40	0.1%
-43.42267	25	0.1%
-43.190266	23	0.1%
-43.19043	19	0.1%
-43.19024	19	0.1%
-43.19053	19	0.1%
-43.19123	19	0.1%
-43.1911	18	< 0.1%
-43.19089	17	< 0.1%
Other values (20859)	35751	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-43.723009	1	< 0.1%
-43.71038	1	< 0.1%
-43.701286	1	< 0.1%
-43.701218	1	< 0.1%
-43.70074	1	< 0.1%
-43.699819	1	< 0.1%
-43.699189	1	< 0.1%
-43.69332	1	< 0.1%
-43.69155	1	< 0.1%
-43.690056	1	< 0.1%

Value	Count	Frequency (%)
-43.1044	1	< 0.1%
-43.104605	1	< 0.1%
-43.10505	1	< 0.1%
-43.105132	1	< 0.1%
-43.10552	1	< 0.1%
-43.10575	1	< 0.1%
-43.105767	1	< 0.1%
-43.105796	1	< 0.1%
-43.10593	1	< 0.1%
-43.10605	1	< 0.1%

room_type
Categorical

IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	281.4 KiB

Entire home/apt	28468
Private room	6910
Shared room	592
Hotel room	38

Length

Max length	15
Median length	15
Mean length	14.353255
Min length	10

Characters and Unicode

Total characters	516832
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Private room
4th row	Private room
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	28468	79.1%
Private room	6910	19.2%
Shared room	592	1.6%
Hotel room	38	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	28468	39.5%
home/apt	28468	39.5%
room	7540	10.5%
private	6910	9.6%
shared	592	0.8%
hotel	38	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	64476	12.5%
t	63884	12.4%
o	43586	8.4%
r	43510	8.4%
m	36008	7.0%
	36008	7.0%
a	35970	7.0%
i	35378	6.8%
h	29060	5.6%
p	28468	5.5%
Other values (9)	100484	19.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	516832	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	64476	12.5%
t	63884	12.4%
o	43586	8.4%
r	43510	8.4%
m	36008	7.0%
	36008	7.0%
a	35970	7.0%
i	35378	6.8%
h	29060	5.6%
p	28468	5.5%
Other values (9)	100484	19.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	516832	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	64476	12.5%
t	63884	12.4%
o	43586	8.4%
r	43510	8.4%
m	36008	7.0%
	36008	7.0%
a	35970	7.0%
i	35378	6.8%
h	29060	5.6%
p	28468	5.5%
Other values (9)	100484	19.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	516832	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	64476	12.5%
t	63884	12.4%
o	43586	8.4%
r	43510	8.4%
m	36008	7.0%
	36008	7.0%
a	35970	7.0%
i	35378	6.8%
h	29060	5.6%
p	28468	5.5%
Other values (9)	100484	19.4%

price
Real number (ℝ)

MISSING SKEWED

Distinct	3230
Distinct (%)	9.4%
Missing	1771
Missing (%)	4.9%
Infinite	0
Infinite (%)	0.0%
Mean	1211.7196

Minimum	0
Maximum	552637
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0
5-th percentile	150
Q1	361
median	660
Q3	1114
95-th percentile	3135.4
Maximum	552637
Range	552637
Interquartile range (IQR)	753

Descriptive statistics

Standard deviation	5790.9374
Coefficient of variation (CV)	4.7791069
Kurtosis	5727.864
Mean	1211.7196
Median Absolute Deviation (MAD)	340
Skewness	66.967076
Sum	41485643
Variance	33534956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	538	1.5%
500	498	1.4%
300	398	1.1%
800	389	1.1%
600	382	1.1%
400	374	1.0%
350	328	0.9%
1500	321	0.9%
200	311	0.9%
250	304	0.8%
Other values (3220)	30394	84.4%
(Missing)	1771	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
26	3	< 0.1%
30	1	< 0.1%
33	1	< 0.1%
35	1	< 0.1%
39	1	< 0.1%
40	2	< 0.1%
41	1	< 0.1%
42	2	< 0.1%
43	2	< 0.1%

Value	Count	Frequency (%)
552637	1	< 0.1%
500000	2	< 0.1%
214786	1	< 0.1%
189982	1	< 0.1%
110130	1	< 0.1%
100118	1	< 0.1%
100000	5	< 0.1%
99000	1	< 0.1%
80080	1	< 0.1%
69157	1	< 0.1%

minimum_nights
Real number (ℝ)

SKEWED

Distinct	71
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4193513

Minimum	1
Maximum	1125
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	7
Maximum	1125
Range	1124
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	22.738877
Coefficient of variation (CV)	5.1452974
Kurtosis	1033.295
Mean	4.4193513
Median Absolute Deviation (MAD)	1
Skewness	28.220927
Sum	159132
Variance	517.05651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	10443	29.0%
1	9243	25.7%
3	7858	21.8%
4	2883	8.0%
5	2446	6.8%
7	1011	2.8%
10	422	1.2%
6	374	1.0%
30	301	0.8%
15	286	0.8%
Other values (61)	741	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9243	25.7%
2	10443	29.0%
3	7858	21.8%
4	2883	8.0%
5	2446	6.8%
6	374	1.0%
7	1011	2.8%
8	57	0.2%
9	14	< 0.1%
10	422	1.2%

Value	Count	Frequency (%)
1125	1	< 0.1%
1000	3	< 0.1%
999	3	< 0.1%
960	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%
630	1	< 0.1%
500	3	< 0.1%
365	38	0.1%
362	1	< 0.1%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	367
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.545545

Minimum	0
Maximum	638
Zeros	10302
Zeros (%)	28.6%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	20
95-th percentile	93
Maximum	638
Range	638
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	40.60038
Coefficient of variation (CV)	2.0772191
Kurtosis	29.974078
Mean	19.545545
Median Absolute Deviation (MAD)	4
Skewness	4.4850733
Sum	703796
Variance	1648.3908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10302	28.6%
1	3233	9.0%
2	2282	6.3%
3	1641	4.6%
4	1308	3.6%
5	1103	3.1%
6	870	2.4%
7	803	2.2%
8	658	1.8%
9	641	1.8%
Other values (357)	13167	36.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10302	28.6%
1	3233	9.0%
2	2282	6.3%
3	1641	4.6%
4	1308	3.6%
5	1103	3.1%
6	870	2.4%
7	803	2.2%
8	658	1.8%
9	641	1.8%

Value	Count	Frequency (%)
638	1	< 0.1%
627	1	< 0.1%
587	1	< 0.1%
555	1	< 0.1%
552	1	< 0.1%
537	1	< 0.1%
532	1	< 0.1%
504	1	< 0.1%
500	1	< 0.1%
484	1	< 0.1%

last_review
Date

MISSING

Distinct	1424
Distinct (%)	5.5%
Missing	10302
Missing (%)	28.6%
Memory size	281.4 KiB

Minimum	2012-02-21 00:00:00
Maximum	2023-12-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	678
Distinct (%)	2.6%
Missing	10302
Missing (%)	28.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.0462771

Minimum	0.01
Maximum	13.75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.2
median	0.67
Q3	1.5
95-th percentile	3.33
Maximum	13.75
Range	13.74
Interquartile range (IQR)	1.3

Descriptive statistics

Standard deviation	1.1578162
Coefficient of variation (CV)	1.1066056
Kurtosis	8.2957752
Mean	1.0462771
Median Absolute Deviation (MAD)	0.53
Skewness	2.215832
Sum	26895.6
Variance	1.3405383
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1	623	1.7%
0.06	563	1.6%
0.08	494	1.4%
0.19	481	1.3%
0.04	453	1.3%
0.02	440	1.2%
0.13	396	1.1%
0.25	370	1.0%
1	354	1.0%
0.17	331	0.9%
Other values (668)	21201	58.9%
(Missing)	10302	28.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	234	0.6%
0.02	440	1.2%
0.03	296	0.8%
0.04	453	1.3%
0.05	205	0.6%
0.06	563	1.6%
0.07	253	0.7%
0.08	494	1.4%
0.09	254	0.7%
0.1	623	1.7%

Value	Count	Frequency (%)
13.75	2	< 0.1%
13.52	1	< 0.1%
11.6	1	< 0.1%
11.41	1	< 0.1%
11.32	1	< 0.1%
11.25	1	< 0.1%
11.03	1	< 0.1%
10.54	1	< 0.1%
10.32	1	< 0.1%
10	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	58
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.4932237

Minimum	1
Maximum	185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	43
Maximum	185
Range	184
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	25.677082
Coefficient of variation (CV)	2.70478
Kurtosis	23.911237
Mean	9.4932237
Median Absolute Deviation (MAD)	1
Skewness	4.7436407
Sum	341832
Variance	659.31253
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	17249	47.9%
2	5372	14.9%
3	2535	7.0%
4	1624	4.5%
5	1000	2.8%
6	924	2.6%
7	581	1.6%
8	504	1.4%
9	432	1.2%
12	372	1.0%
Other values (48)	5415	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	17249	47.9%
2	5372	14.9%
3	2535	7.0%
4	1624	4.5%
5	1000	2.8%
6	924	2.6%
7	581	1.6%
8	504	1.4%
9	432	1.2%
10	330	0.9%

Value	Count	Frequency (%)
185	185	0.5%
157	157	0.4%
145	145	0.4%
142	284	0.8%
128	128	0.4%
85	85	0.2%
80	80	0.2%
77	77	0.2%
69	69	0.2%
57	57	0.2%

availability_365
Real number (ℝ)

ZEROS

Distinct	366
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	172.41891

Minimum	0
Maximum	365
Zeros	5475
Zeros (%)	15.2%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	43
median	160
Q3	316
95-th percentile	364
Maximum	365
Range	365
Interquartile range (IQR)	273

Descriptive statistics

Standard deviation	135.55391
Coefficient of variation (CV)	0.78618933
Kurtosis	-1.535679
Mean	172.41891
Median Absolute Deviation (MAD)	132
Skewness	0.12206185
Sum	6208460
Variance	18374.861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5475	15.2%
365	1553	4.3%
364	643	1.8%
269	498	1.4%
358	430	1.2%
1	404	1.1%
363	396	1.1%
89	341	0.9%
362	341	0.9%
360	330	0.9%
Other values (356)	25597	71.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5475	15.2%
1	404	1.1%
2	90	0.2%
3	95	0.3%
4	85	0.2%
5	74	0.2%
6	92	0.3%
7	80	0.2%
8	72	0.2%
9	73	0.2%

Value	Count	Frequency (%)
365	1553	4.3%
364	643	1.8%
363	396	1.1%
362	341	0.9%
361	238	0.7%
360	330	0.9%
359	277	0.8%
358	430	1.2%
357	227	0.6%
356	231	0.6%

number_of_reviews_ltm
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	99
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.1173073

Minimum	0
Maximum	124
Zeros	14214
Zeros (%)	39.5%
Negative	0
Negative (%)	0.0%
Memory size	281.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	9
95-th percentile	32
Maximum	124
Range	124
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	11.662121
Coefficient of variation (CV)	1.638558
Kurtosis	8.0016977
Mean	7.1173073
Median Absolute Deviation (MAD)	2
Skewness	2.4872391
Sum	256280
Variance	136.00507
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14214	39.5%
1	3431	9.5%
2	2400	6.7%
3	1721	4.8%
4	1282	3.6%
5	1074	3.0%
6	867	2.4%
7	765	2.1%
8	693	1.9%
9	654	1.8%
Other values (89)	8907	24.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14214	39.5%
1	3431	9.5%
2	2400	6.7%
3	1721	4.8%
4	1282	3.6%
5	1074	3.0%
6	867	2.4%
7	765	2.1%
8	693	1.9%
9	654	1.8%

Value	Count	Frequency (%)
124	1	< 0.1%
120	1	< 0.1%
115	1	< 0.1%
113	1	< 0.1%
108	2	< 0.1%
105	2	< 0.1%
98	2	< 0.1%
96	2	< 0.1%
94	1	< 0.1%
93	2	< 0.1%

license
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	36008
Missing (%)	100.0%
Memory size	281.4 KiB

Auto

Heatmap
Table

	availability_365	calculated_host_listings_count	host_id	id	latitude	longitude	minimum_nights	number_of_reviews	number_of_reviews_ltm	price	reviews_per_month	room_type
availability_365	1.000	0.026	0.008	0.003	0.018	-0.126	-0.093	-0.202	-0.182	0.031	-0.187	0.076
calculated_host_listings_count	0.026	1.000	-0.143	0.105	-0.085	0.038	-0.077	0.054	0.078	0.107	0.061	0.082
host_id	0.008	-0.143	1.000	0.452	0.017	-0.076	-0.181	-0.164	-0.036	-0.117	0.157	0.053
id	0.003	0.105	0.452	1.000	-0.007	0.017	-0.224	-0.384	-0.111	-0.029	0.385	0.028
latitude	0.018	-0.085	0.017	-0.007	1.000	0.543	-0.058	-0.026	-0.025	-0.341	-0.037	0.110
longitude	-0.126	0.038	-0.076	0.017	0.543	1.000	0.091	0.136	0.141	-0.015	0.085	0.088
minimum_nights	-0.093	-0.077	-0.181	-0.224	-0.058	0.091	1.000	-0.040	-0.097	0.156	-0.192	0.000
number_of_reviews	-0.202	0.054	-0.164	-0.384	-0.026	0.136	-0.040	1.000	0.868	-0.070	0.594	0.041
number_of_reviews_ltm	-0.182	0.078	-0.036	-0.111	-0.025	0.141	-0.097	0.868	1.000	-0.046	0.804	0.067
price	0.031	0.107	-0.117	-0.029	-0.341	-0.015	0.156	-0.070	-0.046	1.000	0.013	0.013
reviews_per_month	-0.187	0.061	0.157	0.385	-0.037	0.085	-0.192	0.594	0.804	0.013	1.000	0.063
room_type	0.076	0.082	0.053	0.028	0.110	0.088	0.000	0.041	0.067	0.013	0.063	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	license
0	216461	Rental unit in Rio de Janeiro · 1 bedroom · 1 bed · 1 bath	1154263	Zeilma , Da	None	Flamengo	-22.93990	-43.17676	Private room	734.0	1	0	NaT	NaN	1	365	None
1	328626	Rental unit in Rio de Janeiro · 2 bedrooms · 5 beds · 3 baths	1675497	Priscila	None	Santa Teresa	-22.92286	-43.18790	Entire home/apt	1250.0	20	1	2012-02-21	0.01	1	365	None
2	220705	Rental unit in Rio de Janeiro · 1 bedroom · 2 beds · 2.5 baths	1144461	Rachel	None	Copacabana	-22.98246	-43.19376	Private room	300.0	3	0	NaT	NaN	2	0	None
3	329615	Home in Rio de Janeiro · 1 bedroom · 1 bed · 1 bath	1416853	Maria	None	Jardim Botânico	-22.96547	-43.23666	Private room	972.0	1	0	NaT	NaN	1	0	None
4	337345	Rental unit in Rio de Janeiro · 1 bedroom · 2 beds · 1 bath	1714680	Katiuscia	None	Barra da Tijuca	-23.01147	-43.36394	Private room	2411.0	1	0	NaT	NaN	1	365	None
5	247052	Rental unit in Rio de Janeiro · 2 bedrooms · 2 beds · 3 baths	1295841	Osmar	None	Botafogo	-22.95665	-43.18481	Entire home/apt	734.0	5	0	NaT	NaN	1	3	None
6	346694	Rental unit in Rio de Janeiro · 1 bedroom · 1 bed · 1 bath	1612576	Jassanan	None	Vila da Penha	-22.84208	-43.31572	Private room	313.0	1	0	NaT	NaN	1	362	None
7	352718	Rental unit in Rio de Janeiro · 1 bedroom · 1 bed · 3 baths	1786148	Ricardo	None	Copacabana	-22.98127	-43.19215	Private room	500.0	1	2	2013-02-14	0.01	1	357	None
8	355075	Rental unit in Rio de Janeiro · 1 bedroom · 1 bed · 1.5 baths	1707318	Alessandro	None	Flamengo	-22.93527	-43.17834	Private room	978.0	1	0	NaT	NaN	1	365	None
9	86978	Rental unit in Rio de Janeiro · 1 bedroom · 2 beds · 2 baths	476838	Antonio	None	Jacarepaguá	-22.97293	-43.38321	Private room	723.0	1	0	NaT	NaN	1	365	None

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	license
35998	1053711355674934096	Rental unit in Rio de Janeiro · New · 1 bedroom · 1 bath	535697473	Victor	None	Copacabana	-22.967333	-43.181577	Entire home/apt	487.0	1	0	NaT	NaN	2	266	0	None
35999	1053716797020259779	Rental unit in Rio de Janeiro · New · 1 bedroom · 2 beds · 1 bath	154114238	Breno	None	Barra da Tijuca	-23.010436	-43.357412	Entire home/apt	889.0	2	2	2023-12-27	2.0	4	55	2	None
36000	1053720091301615651	Rental unit in Rio de Janeiro · New · 1 bedroom · 1 bath	55209037	Diogo	None	Camorim	-22.980449	-43.422670	Entire home/apt	229.0	1	0	NaT	NaN	1	267	0	None
36001	1053736263866696090	Rental unit in Rio de Janeiro · New · 1 bedroom · 2 beds · 1 bath	13411812	Fernando	None	Copacabana	-22.969913	-43.188015	Entire home/apt	760.0	2	0	NaT	NaN	16	87	0	None
36002	1053743193407023650	Rental unit in Rio de Janeiro · New · 1 bedroom · 2 beds · 1 bath	113031534	João	None	Barra da Tijuca	-23.003550	-43.340740	Entire home/apt	600.0	1	0	NaT	NaN	2	264	0	None
36003	1053746406056980189	Home in Rio de Janeiro · New · 1 bedroom · 4 beds · 1 bath	470173166	Marco	None	Botafogo	-22.956393	-43.182119	Private room	200.0	2	0	NaT	NaN	8	90	0	None
36004	1053756202332288557	Rental unit in Rio de Janeiro · New · 1 bedroom · 2 beds · 1 bath	6000862	Omar Do Rio	None	Copacabana	-22.980547	-43.195863	Entire home/apt	727.0	2	0	NaT	NaN	185	358	0	None
36005	1053789340172837654	Rental unit in Rio de Janeiro · New · 1 bedroom · 1 bed · 1 bath	206898000	Pablo	None	Copacabana	-22.968340	-43.185855	Private room	743.0	1	0	NaT	NaN	1	270	0	None
36006	1053808194231554793	Rental unit in Rio de Janeiro · New · 1 bedroom · 1 bath	536983374	Izaias	None	Vidigal	-22.996260	-43.240830	Entire home/apt	560.0	1	0	NaT	NaN	1	249	0	None
36007	1053823261878675052	Rental unit in Rio de Janeiro · New · 1 bedroom · 1 bed · 1 bath	694816	Samuel	None	Glória	-22.912241	-43.171288	Private room	175.0	2	0	NaT	NaN	1	19	0	None

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample